﻿CREATE VIEW dbo.vw_LocationMeterData_GeoEncoded
AS
SELECT     L.addr_line2, L.addr_city, L.addr_state, L.addr_zip, L.latitude, L.longitude, M.MeterNumber, M.VendorID, M.HeadEndID
FROM         dbo.Location AS L INNER JOIN
                      dbo.Meters AS M ON L.location_id = M.MeterID
WHERE     (L.latitude <> 0) AND (L.longitude <> 0)